﻿<?xml version="1.0" encoding="utf-8" ?>
<Project xmlns="http://schemas.microsoft.com/developer/msbuild/2003" DefaultTargets="Main">
	<!--<Import Project="D:\TeamEOS\Utilities\MSBuildExtensions\Output\MSBuild.BvB.Tasks\MSBuild.BvB.tasks.proj"/>-->
  <UsingTask AssemblyFile="bin\Debug\DataScripter.Tasks.dll" TaskName="TruncateTablesTask" />

  <PropertyGroup>
		<TestName>TruncateTablek Task</TestName>
		<TestDescription>Truncate Table With Foreign Keys</TestDescription>
	</PropertyGroup>

	<!--<ItemGroup>
		<TablestoTruncate Include="datascripter.TableA" />
		<TablestoTruncate Include="datascripter.TableB" />
	</ItemGroup>

	<Target Name="Main">

		<TruncateTablesTask Tables="@(TablestoTruncate)" Database="DB_TestData" Server="tbnkdb03" Quiet="false" >
			<Output TaskParameter="Output" PropertyName="GeneratedSql" />
		</TruncateTablesTask>

		<SQLTask Database="DB_TestData" Server="tbnkdb03" Quiet="false" Request="$(GeneratedSql)" />

	</Target>-->

  <ItemGroup>
    <TablestoTruncate Include="Auditing" />
    <TablestoTruncate Include="AuditLog" />
    <TablestoTruncate Include="ContextState" />
    <TablestoTruncate Include="History" />
    <TablestoTruncate Include="WorkSession" />
    <!--<TablestoTruncate Include="Application" />-->
  </ItemGroup>

  <Target Name="Main">

    <TruncateTablesTask Tables="@(TablestoTruncate)" Database="EOSPRM" Server="qbappl10" Quiet="false" >
      <Output TaskParameter="Output" PropertyName="GeneratedSql" />
    </TruncateTablesTask>

    <!--<SQLTask Database="EOSPRM" Server="qbappl10" Quiet="false" Request="$(GeneratedSql)" />-->

  </Target>


</Project>